Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 500 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 58.7 KiB |
| Average record size in memory | 120.3 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 2 |
duration is highly overall correlated with profit and 7 other fields | High correlation |
profit is highly overall correlated with duration and 7 other fields | High correlation |
acq_exp is highly overall correlated with acq_exp_sq | High correlation |
ret_exp is highly overall correlated with duration and 7 other fields | High correlation |
acq_exp_sq is highly overall correlated with acq_exp | High correlation |
ret_exp_sq is highly overall correlated with duration and 7 other fields | High correlation |
freq is highly overall correlated with duration and 7 other fields | High correlation |
freq_sq is highly overall correlated with duration and 7 other fields | High correlation |
crossbuy is highly overall correlated with duration and 7 other fields | High correlation |
sow is highly overall correlated with duration and 7 other fields | High correlation |
acquisition is highly overall correlated with duration and 7 other fields | High correlation |
customer is uniformly distributed | Uniform |
customer has unique values | Unique |
duration has 162 (32.4%) zeros | Zeros |
ret_exp has 162 (32.4%) zeros | Zeros |
ret_exp_sq has 162 (32.4%) zeros | Zeros |
freq has 162 (32.4%) zeros | Zeros |
freq_sq has 162 (32.4%) zeros | Zeros |
crossbuy has 162 (32.4%) zeros | Zeros |
sow has 162 (32.4%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-15 19:25:05.236991 |
|---|---|
| Analysis finished | 2023-04-15 19:25:22.093613 |
| Duration | 16.86 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
customer
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 500 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 250.5 |
| Minimum | 1 |
|---|---|
| Maximum | 500 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 25.95 |
| Q1 | 125.75 |
| median | 250.5 |
| Q3 | 375.25 |
| 95-th percentile | 475.05 |
| Maximum | 500 |
| Range | 499 |
| Interquartile range (IQR) | 249.5 |
Descriptive statistics
| Standard deviation | 144.48183 |
|---|---|
| Coefficient of variation (CV) | 0.57677378 |
| Kurtosis | -1.2 |
| Mean | 250.5 |
| Median Absolute Deviation (MAD) | 125 |
| Skewness | 0 |
| Sum | 125250 |
| Variance | 20875 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1 | 0.2% |
| 330 | 1 | 0.2% |
| 343 | 1 | 0.2% |
| 342 | 1 | 0.2% |
| 341 | 1 | 0.2% |
| 340 | 1 | 0.2% |
| 339 | 1 | 0.2% |
| 338 | 1 | 0.2% |
| 337 | 1 | 0.2% |
| 336 | 1 | 0.2% |
| Other values (490) | 490 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 500 | 1 | |
| 499 | 1 | |
| 498 | 1 | |
| 497 | 1 | |
| 496 | 1 | |
| 495 | 1 | |
| 494 | 1 | |
| 493 | 1 | |
| 492 | 1 | |
| 491 | 1 |
acquisition
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 500 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 338 | |
| 0 | 162 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 338 | |
| 0 | 162 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 338 | |
| 0 | 162 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 500 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 338 | |
| 0 | 162 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 500 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 338 | |
| 0 | 162 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 500 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 338 | |
| 0 | 162 |
duration
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 278 |
|---|---|
| Distinct (%) | 55.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 742.454 |
| Minimum | 0 |
|---|---|
| Maximum | 1673 |
| Zeros | 162 |
| Zeros (%) | 32.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 957.5 |
| Q3 | 1146.25 |
| 95-th percentile | 1457.15 |
| Maximum | 1673 |
| Range | 1673 |
| Interquartile range (IQR) | 1146.25 |
Descriptive statistics
| Standard deviation | 544.47204 |
|---|---|
| Coefficient of variation (CV) | 0.73334111 |
| Kurtosis | -1.3758027 |
| Mean | 742.454 |
| Median Absolute Deviation (MAD) | 279.5 |
| Skewness | -0.40648538 |
| Sum | 371227 |
| Variance | 296449.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 950 | 4 | 0.8% |
| 1122 | 4 | 0.8% |
| 1207 | 3 | 0.6% |
| 1050 | 3 | 0.6% |
| 1006 | 3 | 0.6% |
| 1039 | 3 | 0.6% |
| 1252 | 3 | 0.6% |
| 982 | 3 | 0.6% |
| 1242 | 3 | 0.6% |
| Other values (268) | 309 |
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 654 | 1 | 0.2% |
| 655 | 1 | 0.2% |
| 658 | 1 | 0.2% |
| 661 | 1 | 0.2% |
| 678 | 1 | 0.2% |
| 683 | 1 | 0.2% |
| 687 | 1 | 0.2% |
| 689 | 1 | 0.2% |
| 694 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 1673 | 1 | |
| 1660 | 1 | |
| 1656 | 1 | |
| 1649 | 1 | |
| 1647 | 1 | |
| 1643 | 1 | |
| 1635 | 1 | |
| 1633 | 1 | |
| 1631 | 1 | |
| 1617 | 1 |
profit
Real number (ℝ)
| Distinct | 498 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2403.8428 |
| Minimum | -1027.04 |
|---|---|
| Maximum | 6134.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 162 |
| Negative (%) | 32.4% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | -1027.04 |
|---|---|
| 5-th percentile | -754.0105 |
| Q1 | -316.3175 |
| median | 3369.925 |
| Q3 | 3931.5975 |
| 95-th percentile | 4785.397 |
| Maximum | 6134.3 |
| Range | 7161.34 |
| Interquartile range (IQR) | 4247.915 |
Descriptive statistics
| Standard deviation | 2083.1912 |
|---|---|
| Coefficient of variation (CV) | 0.86660875 |
| Kurtosis | -1.3727848 |
| Mean | 2403.8428 |
| Median Absolute Deviation (MAD) | 785.16 |
| Skewness | -0.54320082 |
| Sum | 1201921.4 |
| Variance | 4339685.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3605.86 | 2 | 0.4% |
| 3718.4 | 2 | 0.4% |
| 6134.3 | 1 | 0.2% |
| 3535 | 1 | 0.2% |
| 3487.88 | 1 | 0.2% |
| -852.25 | 1 | 0.2% |
| -244 | 1 | 0.2% |
| 4084.57 | 1 | 0.2% |
| 3388.2 | 1 | 0.2% |
| -503.88 | 1 | 0.2% |
| Other values (488) | 488 |
| Value | Count | Frequency (%) |
| -1027.04 | 1 | |
| -1016.18 | 1 | |
| -970.31 | 1 | |
| -902.47 | 1 | |
| -891.97 | 1 | |
| -868.21 | 1 | |
| -852.25 | 1 | |
| -851.77 | 1 | |
| -838.33 | 1 | |
| -837.83 | 1 |
| Value | Count | Frequency (%) |
| 6134.3 | 1 | |
| 5655.11 | 1 | |
| 5652.77 | 1 | |
| 5569.71 | 1 | |
| 5559.1 | 1 | |
| 5446.32 | 1 | |
| 5444.28 | 1 | |
| 5435.51 | 1 | |
| 5433.94 | 1 | |
| 5338.39 | 1 |
acq_exp
Real number (ℝ)
| Distinct | 497 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 493.351 |
| Minimum | 1.21 |
|---|---|
| Maximum | 1027.04 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 1.21 |
|---|---|
| 5-th percentile | 220.64 |
| Q1 | 384.1375 |
| median | 491.66 |
| Q3 | 600.205 |
| 95-th percentile | 774.9025 |
| Maximum | 1027.04 |
| Range | 1025.83 |
| Interquartile range (IQR) | 216.0675 |
Descriptive statistics
| Standard deviation | 166.948 |
|---|---|
| Coefficient of variation (CV) | 0.33839599 |
| Kurtosis | 0.022706289 |
| Mean | 493.351 |
| Median Absolute Deviation (MAD) | 108.525 |
| Skewness | 0.12858104 |
| Sum | 246675.5 |
| Variance | 27871.634 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 482.33 | 2 | 0.4% |
| 492 | 2 | 0.4% |
| 387.23 | 2 | 0.4% |
| 693.54 | 1 | 0.2% |
| 429.09 | 1 | 0.2% |
| 244 | 1 | 0.2% |
| 504.18 | 1 | 0.2% |
| 582.78 | 1 | 0.2% |
| 503.88 | 1 | 0.2% |
| 627.99 | 1 | 0.2% |
| Other values (487) | 487 |
| Value | Count | Frequency (%) |
| 1.21 | 1 | |
| 43.15 | 1 | |
| 120.86 | 1 | |
| 121.18 | 1 | |
| 136.26 | 1 | |
| 147.12 | 1 | |
| 151.04 | 1 | |
| 165.98 | 1 | |
| 167.09 | 1 | |
| 167.99 | 1 |
| Value | Count | Frequency (%) |
| 1027.04 | 1 | |
| 1016.18 | 1 | |
| 970.31 | 1 | |
| 902.47 | 1 | |
| 891.97 | 1 | |
| 868.21 | 1 | |
| 864.1 | 1 | |
| 852.25 | 1 | |
| 851.77 | 1 | |
| 838.33 | 1 |
ret_exp
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 339 |
|---|---|
| Distinct (%) | 67.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 336.26198 |
| Minimum | 0 |
|---|---|
| Maximum | 1094.96 |
| Zeros | 162 |
| Zeros (%) | 32.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 398.095 |
| Q3 | 514.2625 |
| 95-th percentile | 747.588 |
| Maximum | 1094.96 |
| Range | 1094.96 |
| Interquartile range (IQR) | 514.2625 |
Descriptive statistics
| Standard deviation | 266.5893 |
|---|---|
| Coefficient of variation (CV) | 0.79280239 |
| Kurtosis | -0.7538814 |
| Mean | 336.26198 |
| Median Absolute Deviation (MAD) | 165.7 |
| Skewness | 0.094315153 |
| Sum | 168130.99 |
| Variance | 71069.855 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 971.56 | 1 | 0.2% |
| 340.15 | 1 | 0.2% |
| 499.59 | 1 | 0.2% |
| 491.75 | 1 | 0.2% |
| 539.03 | 1 | 0.2% |
| 316.05 | 1 | 0.2% |
| 308.53 | 1 | 0.2% |
| 978.52 | 1 | 0.2% |
| 350.7 | 1 | 0.2% |
| Other values (329) | 329 |
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 229.87 | 1 | 0.2% |
| 231.41 | 1 | 0.2% |
| 234.06 | 1 | 0.2% |
| 235.84 | 1 | 0.2% |
| 237.12 | 1 | 0.2% |
| 238.77 | 1 | 0.2% |
| 246.75 | 1 | 0.2% |
| 252 | 1 | 0.2% |
| 262.45 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 1094.96 | 1 | |
| 1082.37 | 1 | |
| 1001.8 | 1 | |
| 996.86 | 1 | |
| 983.56 | 1 | |
| 978.52 | 1 | |
| 971.56 | 1 | |
| 965.4 | 1 | |
| 953.49 | 1 | |
| 925.11 | 1 |
acq_exp_sq
Real number (ℝ)
| Distinct | 497 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 271211.1 |
| Minimum | 1.46 |
|---|---|
| Maximum | 1054811.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 1.46 |
|---|---|
| 5-th percentile | 48682.038 |
| Q1 | 147561.95 |
| median | 241729.67 |
| Q3 | 360246.04 |
| 95-th percentile | 600474.91 |
| Maximum | 1054811.2 |
| Range | 1054809.7 |
| Interquartile range (IQR) | 212684.09 |
Descriptive statistics
| Standard deviation | 172829.25 |
|---|---|
| Coefficient of variation (CV) | 0.63724992 |
| Kurtosis | 1.6916648 |
| Mean | 271211.1 |
| Median Absolute Deviation (MAD) | 100210.58 |
| Skewness | 1.1059475 |
| Sum | 1.3560555 × 108 |
| Variance | 2.986995 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 232642.23 | 2 | 0.4% |
| 242064 | 2 | 0.4% |
| 149947.07 | 2 | 0.4% |
| 480997.73 | 1 | 0.2% |
| 184118.23 | 1 | 0.2% |
| 59536 | 1 | 0.2% |
| 254197.47 | 1 | 0.2% |
| 339632.53 | 1 | 0.2% |
| 253895.05 | 1 | 0.2% |
| 394371.44 | 1 | 0.2% |
| Other values (487) | 487 |
| Value | Count | Frequency (%) |
| 1.46 | 1 | |
| 1861.92 | 1 | |
| 14607.14 | 1 | |
| 14684.59 | 1 | |
| 18566.79 | 1 | |
| 21644.29 | 1 | |
| 22813.08 | 1 | |
| 27549.36 | 1 | |
| 27919.07 | 1 | |
| 28220.64 | 1 |
| Value | Count | Frequency (%) |
| 1054811.16 | 1 | |
| 1032621.79 | 1 | |
| 941501.5 | 1 | |
| 814452.1 | 1 | |
| 795610.48 | 1 | |
| 753788.6 | 1 | |
| 746668.81 | 1 | |
| 726330.06 | 1 | |
| 725512.13 | 1 | |
| 702797.19 | 1 |
ret_exp_sq
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 339 |
|---|---|
| Distinct (%) | 67.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 183999.83 |
| Minimum | 0 |
|---|---|
| Maximum | 1198937.4 |
| Zeros | 162 |
| Zeros (%) | 32.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 158479.67 |
| Q3 | 264466.08 |
| 95-th percentile | 558894.61 |
| Maximum | 1198937.4 |
| Range | 1198937.4 |
| Interquartile range (IQR) | 264466.08 |
Descriptive statistics
| Standard deviation | 201982.6 |
|---|---|
| Coefficient of variation (CV) | 1.0977325 |
| Kurtosis | 4.7905071 |
| Mean | 183999.83 |
| Median Absolute Deviation (MAD) | 155460.96 |
| Skewness | 1.8455725 |
| Sum | 91999917 |
| Variance | 4.0796969 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 943928.83 | 1 | 0.2% |
| 115702.02 | 1 | 0.2% |
| 249590.17 | 1 | 0.2% |
| 241818.06 | 1 | 0.2% |
| 290553.34 | 1 | 0.2% |
| 99887.6 | 1 | 0.2% |
| 95190.76 | 1 | 0.2% |
| 957501.39 | 1 | 0.2% |
| 122990.49 | 1 | 0.2% |
| Other values (329) | 329 |
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 52840.22 | 1 | 0.2% |
| 53550.59 | 1 | 0.2% |
| 54784.08 | 1 | 0.2% |
| 55620.51 | 1 | 0.2% |
| 56225.89 | 1 | 0.2% |
| 57011.11 | 1 | 0.2% |
| 60885.56 | 1 | 0.2% |
| 63504 | 1 | 0.2% |
| 68880 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 1198937.4 | 1 | |
| 1171524.82 | 1 | |
| 1003603.24 | 1 | |
| 993729.86 | 1 | |
| 967390.27 | 1 | |
| 957501.39 | 1 | |
| 943928.83 | 1 | |
| 931997.16 | 1 | |
| 909143.18 | 1 | |
| 855828.51 | 1 |
freq
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 22 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.22 |
| Minimum | 0 |
|---|---|
| Maximum | 21 |
| Zeros | 162 |
| Zeros (%) | 32.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 6 |
| Q3 | 11 |
| 95-th percentile | 15 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 5.5339723 |
|---|---|
| Coefficient of variation (CV) | 0.88970616 |
| Kurtosis | -0.96785092 |
| Mean | 6.22 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.34422912 |
| Sum | 3110 |
| Variance | 30.62485 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=22)
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 9 | 37 | 7.4% |
| 11 | 36 | 7.2% |
| 10 | 28 | 5.6% |
| 6 | 27 | 5.4% |
| 5 | 27 | 5.4% |
| 8 | 25 | 5.0% |
| 12 | 23 | 4.6% |
| 7 | 22 | 4.4% |
| 13 | 17 | 3.4% |
| Other values (12) | 96 |
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 1 | 12 | 2.4% |
| 2 | 9 | 1.8% |
| 3 | 8 | 1.6% |
| 4 | 14 | 2.8% |
| 5 | 27 | 5.4% |
| 6 | 27 | 5.4% |
| 7 | 22 | 4.4% |
| 8 | 25 | 5.0% |
| 9 | 37 | 7.4% |
| Value | Count | Frequency (%) |
| 21 | 2 | 0.4% |
| 20 | 2 | 0.4% |
| 19 | 3 | 0.6% |
| 18 | 6 | 1.2% |
| 17 | 1 | 0.2% |
| 16 | 10 | |
| 15 | 13 | |
| 14 | 16 | |
| 13 | 17 | |
| 12 | 23 |
freq_sq
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 22 |
|---|---|
| Distinct (%) | 4.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.252 |
| Minimum | 0 |
|---|---|
| Maximum | 441 |
| Zeros | 162 |
| Zeros (%) | 32.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 36 |
| Q3 | 121 |
| 95-th percentile | 225 |
| Maximum | 441 |
| Range | 441 |
| Interquartile range (IQR) | 121 |
Descriptive statistics
| Standard deviation | 84.551134 |
|---|---|
| Coefficient of variation (CV) | 1.2209197 |
| Kurtosis | 2.6412152 |
| Mean | 69.252 |
| Median Absolute Deviation (MAD) | 36 |
| Skewness | 1.5680946 |
| Sum | 34626 |
| Variance | 7148.8943 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=22)
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 81 | 37 | 7.4% |
| 121 | 36 | 7.2% |
| 100 | 28 | 5.6% |
| 36 | 27 | 5.4% |
| 25 | 27 | 5.4% |
| 64 | 25 | 5.0% |
| 144 | 23 | 4.6% |
| 49 | 22 | 4.4% |
| 169 | 17 | 3.4% |
| Other values (12) | 96 |
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 1 | 12 | 2.4% |
| 4 | 9 | 1.8% |
| 9 | 8 | 1.6% |
| 16 | 14 | 2.8% |
| 25 | 27 | 5.4% |
| 36 | 27 | 5.4% |
| 49 | 22 | 4.4% |
| 64 | 25 | 5.0% |
| 81 | 37 | 7.4% |
| Value | Count | Frequency (%) |
| 441 | 2 | 0.4% |
| 400 | 2 | 0.4% |
| 361 | 3 | 0.6% |
| 324 | 6 | 1.2% |
| 289 | 1 | 0.2% |
| 256 | 10 | |
| 225 | 13 | |
| 196 | 16 | |
| 169 | 17 | |
| 144 | 23 |
crossbuy
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 12 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.052 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 162 |
| Zeros (%) | 32.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 7 |
| 95-th percentile | 9 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 3.2419618 |
|---|---|
| Coefficient of variation (CV) | 0.8000893 |
| Kurtosis | -1.313598 |
| Mean | 4.052 |
| Median Absolute Deviation (MAD) | 2.5 |
| Skewness | -0.034735021 |
| Sum | 2026 |
| Variance | 10.510317 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 5 | 64 | 12.8% |
| 6 | 61 | 12.2% |
| 7 | 57 | 11.4% |
| 8 | 47 | 9.4% |
| 4 | 43 | 8.6% |
| 3 | 25 | 5.0% |
| 9 | 19 | 3.8% |
| 10 | 9 | 1.8% |
| 1 | 5 | 1.0% |
| Other values (2) | 8 | 1.6% |
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 1 | 5 | 1.0% |
| 2 | 4 | 0.8% |
| 3 | 25 | 5.0% |
| 4 | 43 | 8.6% |
| 5 | 64 | 12.8% |
| 6 | 61 | 12.2% |
| 7 | 57 | 11.4% |
| 8 | 47 | 9.4% |
| 9 | 19 | 3.8% |
| Value | Count | Frequency (%) |
| 11 | 4 | 0.8% |
| 10 | 9 | 1.8% |
| 9 | 19 | 3.8% |
| 8 | 47 | |
| 7 | 57 | |
| 6 | 61 | |
| 5 | 64 | |
| 4 | 43 | |
| 3 | 25 | 5.0% |
| 2 | 4 | 0.8% |
sow
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 89 |
|---|---|
| Distinct (%) | 17.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.88 |
| Minimum | 0 |
|---|---|
| Maximum | 116 |
| Zeros | 162 |
| Zeros (%) | 32.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 44 |
| Q3 | 66 |
| 95-th percentile | 85 |
| Maximum | 116 |
| Range | 116 |
| Interquartile range (IQR) | 66 |
Descriptive statistics
| Standard deviation | 31.805294 |
|---|---|
| Coefficient of variation (CV) | 0.81803741 |
| Kurtosis | -1.3051346 |
| Mean | 38.88 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 0.016694844 |
| Sum | 19440 |
| Variance | 1011.5768 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 66 | 12 | 2.4% |
| 54 | 11 | 2.2% |
| 40 | 9 | 1.8% |
| 80 | 9 | 1.8% |
| 67 | 8 | 1.6% |
| 76 | 8 | 1.6% |
| 70 | 8 | 1.6% |
| 62 | 8 | 1.6% |
| 68 | 8 | 1.6% |
| Other values (79) | 257 |
| Value | Count | Frequency (%) |
| 0 | 162 | |
| 1 | 2 | 0.4% |
| 5 | 2 | 0.4% |
| 7 | 1 | 0.2% |
| 8 | 1 | 0.2% |
| 9 | 1 | 0.2% |
| 12 | 2 | 0.4% |
| 13 | 1 | 0.2% |
| 18 | 1 | 0.2% |
| 22 | 3 | 0.6% |
| Value | Count | Frequency (%) |
| 116 | 1 | 0.2% |
| 115 | 1 | 0.2% |
| 107 | 1 | 0.2% |
| 104 | 1 | 0.2% |
| 101 | 1 | 0.2% |
| 100 | 3 | |
| 99 | 1 | 0.2% |
| 98 | 1 | 0.2% |
| 95 | 2 | |
| 94 | 2 |
industry
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 28.4 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 500 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 261 | |
| 0 | 239 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 261 | |
| 0 | 239 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 261 | |
| 0 | 239 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 500 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 261 | |
| 0 | 239 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 500 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 261 | |
| 0 | 239 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 500 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 261 | |
| 0 | 239 |
revenue
Real number (ℝ)
| Distinct | 469 |
|---|---|
| Distinct (%) | 93.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.54008 |
| Minimum | 14.49 |
|---|---|
| Maximum | 65.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 14.49 |
|---|---|
| 5-th percentile | 23.9705 |
| Q1 | 33.53 |
| median | 41.43 |
| Q3 | 47.515 |
| 95-th percentile | 55.4925 |
| Maximum | 65.1 |
| Range | 50.61 |
| Interquartile range (IQR) | 13.985 |
Descriptive statistics
| Standard deviation | 9.6724441 |
|---|---|
| Coefficient of variation (CV) | 0.23858967 |
| Kurtosis | -0.36419077 |
| Mean | 40.54008 |
| Median Absolute Deviation (MAD) | 6.835 |
| Skewness | -0.11270265 |
| Sum | 20270.04 |
| Variance | 93.556176 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 44.31 | 3 | 0.6% |
| 47.2 | 2 | 0.4% |
| 41.55 | 2 | 0.4% |
| 42.05 | 2 | 0.4% |
| 52.2 | 2 | 0.4% |
| 38.86 | 2 | 0.4% |
| 46.64 | 2 | 0.4% |
| 50.14 | 2 | 0.4% |
| 41.32 | 2 | 0.4% |
| 36.55 | 2 | 0.4% |
| Other values (459) | 479 |
| Value | Count | Frequency (%) |
| 14.49 | 1 | |
| 15.86 | 1 | |
| 16.29 | 1 | |
| 17.74 | 1 | |
| 19.15 | 1 | |
| 19.4 | 1 | |
| 19.51 | 1 | |
| 19.94 | 1 | |
| 20.15 | 1 | |
| 20.3 | 1 |
| Value | Count | Frequency (%) |
| 65.1 | 1 | |
| 65.03 | 1 | |
| 64.48 | 1 | |
| 63.17 | 1 | |
| 62.47 | 1 | |
| 61.24 | 1 | |
| 60.96 | 1 | |
| 60.71 | 1 | |
| 60 | 1 | |
| 59.7 | 1 |
employees
Real number (ℝ)
| Distinct | 383 |
|---|---|
| Distinct (%) | 76.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 671.532 |
| Minimum | 18 |
|---|---|
| Maximum | 1461 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 309.95 |
| Q1 | 503 |
| median | 657.5 |
| Q3 | 826 |
| 95-th percentile | 1105.35 |
| Maximum | 1461 |
| Range | 1443 |
| Interquartile range (IQR) | 323 |
Descriptive statistics
| Standard deviation | 242.9914 |
|---|---|
| Coefficient of variation (CV) | 0.36184634 |
| Kurtosis | 0.05821867 |
| Mean | 671.532 |
| Median Absolute Deviation (MAD) | 162.5 |
| Skewness | 0.22914002 |
| Sum | 335766 |
| Variance | 59044.819 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 667 | 5 | 1.0% |
| 423 | 4 | 0.8% |
| 589 | 4 | 0.8% |
| 934 | 3 | 0.6% |
| 767 | 3 | 0.6% |
| 896 | 3 | 0.6% |
| 455 | 3 | 0.6% |
| 937 | 3 | 0.6% |
| 818 | 3 | 0.6% |
| 711 | 3 | 0.6% |
| Other values (373) | 466 |
| Value | Count | Frequency (%) |
| 18 | 1 | |
| 24 | 1 | |
| 56 | 1 | |
| 104 | 1 | |
| 143 | 1 | |
| 161 | 1 | |
| 165 | 1 | |
| 171 | 1 | |
| 176 | 1 | |
| 177 | 1 |
| Value | Count | Frequency (%) |
| 1461 | 1 | |
| 1423 | 1 | |
| 1361 | 1 | |
| 1354 | 1 | |
| 1337 | 1 | |
| 1259 | 1 | |
| 1253 | 1 | |
| 1203 | 1 | |
| 1180 | 1 | |
| 1174 | 1 |
| customer | duration | profit | acq_exp | ret_exp | acq_exp_sq | ret_exp_sq | freq | freq_sq | crossbuy | sow | revenue | employees | acquisition | industry | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer | 1.000 | 0.026 | 0.024 | -0.032 | 0.027 | -0.032 | 0.027 | 0.040 | 0.040 | 0.071 | 0.011 | 0.016 | 0.027 | 0.000 | 0.000 |
| duration | 0.026 | 1.000 | 0.929 | 0.036 | 0.990 | 0.036 | 0.990 | 0.646 | 0.646 | 0.714 | 0.692 | 0.178 | 0.388 | 0.994 | 0.241 |
| profit | 0.024 | 0.929 | 1.000 | 0.099 | 0.928 | 0.099 | 0.928 | 0.663 | 0.663 | 0.724 | 0.702 | 0.194 | 0.439 | 0.994 | 0.236 |
| acq_exp | -0.032 | 0.036 | 0.099 | 1.000 | 0.028 | 1.000 | 0.028 | 0.026 | 0.026 | 0.042 | 0.058 | 0.071 | -0.010 | 0.299 | 0.000 |
| ret_exp | 0.027 | 0.990 | 0.928 | 0.028 | 1.000 | 0.028 | 1.000 | 0.699 | 0.699 | 0.710 | 0.679 | 0.179 | 0.408 | 0.993 | 0.225 |
| acq_exp_sq | -0.032 | 0.036 | 0.099 | 1.000 | 0.028 | 1.000 | 0.028 | 0.026 | 0.026 | 0.042 | 0.058 | 0.071 | -0.010 | 0.282 | 0.000 |
| ret_exp_sq | 0.027 | 0.990 | 0.928 | 0.028 | 1.000 | 0.028 | 1.000 | 0.699 | 0.699 | 0.710 | 0.679 | 0.179 | 0.408 | 0.820 | 0.246 |
| freq | 0.040 | 0.646 | 0.663 | 0.026 | 0.699 | 0.026 | 0.699 | 1.000 | 1.000 | 0.691 | 0.677 | 0.170 | 0.444 | 0.902 | 0.229 |
| freq_sq | 0.040 | 0.646 | 0.663 | 0.026 | 0.699 | 0.026 | 0.699 | 1.000 | 1.000 | 0.691 | 0.677 | 0.170 | 0.444 | 0.655 | 0.086 |
| crossbuy | 0.071 | 0.714 | 0.724 | 0.042 | 0.710 | 0.042 | 0.710 | 0.691 | 0.691 | 1.000 | 0.692 | 0.177 | 0.426 | 0.969 | 0.228 |
| sow | 0.011 | 0.692 | 0.702 | 0.058 | 0.679 | 0.058 | 0.679 | 0.677 | 0.677 | 0.692 | 1.000 | 0.220 | 0.401 | 0.960 | 0.245 |
| revenue | 0.016 | 0.178 | 0.194 | 0.071 | 0.179 | 0.071 | 0.179 | 0.170 | 0.170 | 0.177 | 0.220 | 1.000 | 0.055 | 0.219 | 0.000 |
| employees | 0.027 | 0.388 | 0.439 | -0.010 | 0.408 | -0.010 | 0.408 | 0.444 | 0.444 | 0.426 | 0.401 | 0.055 | 1.000 | 0.500 | 0.000 |
| acquisition | 0.000 | 0.994 | 0.994 | 0.299 | 0.993 | 0.282 | 0.820 | 0.902 | 0.655 | 0.969 | 0.960 | 0.219 | 0.500 | 1.000 | 0.236 |
| industry | 0.000 | 0.241 | 0.236 | 0.000 | 0.225 | 0.000 | 0.246 | 0.229 | 0.086 | 0.228 | 0.245 | 0.000 | 0.000 | 0.236 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| customer | acquisition | duration | profit | acq_exp | ret_exp | acq_exp_sq | ret_exp_sq | freq | freq_sq | crossbuy | sow | industry | revenue | employees | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1 | 1635 | 6134.30 | 693.54 | 971.56 | 480997.73 | 943928.83 | 6 | 36 | 5 | 95 | 1 | 47.20 | 898 |
| 1 | 2 | 1 | 1039 | 3523.62 | 460.03 | 449.53 | 211627.60 | 202077.22 | 11 | 121 | 6 | 22 | 0 | 45.11 | 686 |
| 2 | 3 | 1 | 1288 | 4080.62 | 249.03 | 805.04 | 62015.94 | 648089.40 | 21 | 441 | 6 | 90 | 0 | 29.10 | 1423 |
| 3 | 4 | 0 | 0 | -638.47 | 638.47 | 0.00 | 407643.94 | 0.00 | 0 | 0 | 0 | 0 | 0 | 40.64 | 181 |
| 4 | 5 | 1 | 1631 | 5446.32 | 588.98 | 919.84 | 346897.44 | 846105.63 | 2 | 4 | 9 | 80 | 0 | 48.72 | 631 |
| 5 | 6 | 1 | 942 | 3488.07 | 568.65 | 365.11 | 323362.82 | 133305.31 | 7 | 49 | 4 | 48 | 1 | 35.43 | 617 |
| 6 | 7 | 1 | 799 | 2704.89 | 373.15 | 341.42 | 139240.92 | 116567.62 | 15 | 225 | 5 | 51 | 0 | 50.96 | 911 |
| 7 | 8 | 1 | 1081 | 3577.98 | 366.49 | 509.22 | 134314.92 | 259305.01 | 13 | 169 | 5 | 23 | 1 | 39.53 | 645 |
| 8 | 9 | 0 | 0 | -284.96 | 284.96 | 0.00 | 81202.20 | 0.00 | 0 | 0 | 0 | 0 | 0 | 29.33 | 530 |
| 9 | 10 | 0 | 0 | -292.54 | 292.54 | 0.00 | 85579.65 | 0.00 | 0 | 0 | 0 | 0 | 1 | 42.13 | 511 |
| customer | acquisition | duration | profit | acq_exp | ret_exp | acq_exp_sq | ret_exp_sq | freq | freq_sq | crossbuy | sow | industry | revenue | employees | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 490 | 491 | 0 | 0 | -268.42 | 268.42 | 0.00 | 72049.30 | 0.00 | 0 | 0 | 0 | 0 | 1 | 49.83 | 468 |
| 491 | 492 | 0 | 0 | -364.59 | 364.59 | 0.00 | 132925.87 | 0.00 | 0 | 0 | 0 | 0 | 0 | 39.76 | 511 |
| 492 | 493 | 1 | 1068 | 3440.18 | 345.52 | 454.24 | 119384.07 | 206333.98 | 2 | 4 | 7 | 40 | 1 | 55.25 | 629 |
| 493 | 494 | 1 | 1036 | 4111.34 | 592.71 | 573.45 | 351305.14 | 328844.90 | 20 | 400 | 6 | 28 | 1 | 49.90 | 622 |
| 494 | 495 | 1 | 1096 | 3247.85 | 270.48 | 488.26 | 73159.43 | 238397.83 | 11 | 121 | 6 | 67 | 1 | 35.81 | 1461 |
| 495 | 496 | 1 | 1101 | 3519.55 | 281.80 | 506.73 | 79411.24 | 256775.29 | 11 | 121 | 8 | 46 | 1 | 43.38 | 818 |
| 496 | 497 | 1 | 1643 | 5079.82 | 482.33 | 953.49 | 232642.23 | 909143.18 | 10 | 100 | 5 | 61 | 0 | 23.10 | 554 |
| 497 | 498 | 1 | 975 | 3240.56 | 350.76 | 403.23 | 123032.58 | 162594.43 | 8 | 64 | 8 | 63 | 1 | 41.35 | 772 |
| 498 | 499 | 0 | 0 | -473.63 | 473.63 | 0.00 | 224325.38 | 0.00 | 0 | 0 | 0 | 0 | 0 | 43.81 | 509 |
| 499 | 500 | 1 | 764 | 3552.25 | 731.41 | 285.47 | 534960.59 | 81493.12 | 9 | 81 | 9 | 68 | 1 | 25.48 | 1057 |